CREATE TABLE [dbo].[ActivityImporter]
(
[SEQN] [int] NOT NULL CONSTRAINT [DF_ActivityImporter_SEQN] DEFAULT ((0)),
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_ID] DEFAULT (''),
[ACTIVITY_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_ACTIVITY_TYPE] DEFAULT (''),
[TRANSACTION_DATE] [datetime] NULL,
[EFFECTIVE_DATE] [datetime] NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_PRODUCT_CODE] DEFAULT (''),
[OTHER_CODE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_OTHER_CODE] DEFAULT (''),
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_DESCRIPTION] DEFAULT (''),
[SOURCE_SYSTEM] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_SOURCE_SYSTEM] DEFAULT (''),
[SOURCE_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_SOURCE_CODE] DEFAULT (''),
[QUANTITY] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_ActivityImporter_QUANTITY] DEFAULT ((0)),
[AMOUNT] [money] NOT NULL CONSTRAINT [DF_ActivityImporter_AMOUNT] DEFAULT ((0)),
[CATEGORY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_CATEGORY] DEFAULT (''),
[UNITS] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_ActivityImporter_UNITS] DEFAULT ((0)),
[THRU_DATE] [datetime] NULL,
[MEMBER_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_MEMBER_TYPE] DEFAULT (''),
[ACTION_CODES] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_ACTION_CODES] DEFAULT (''),
[PAY_METHOD] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_PAY_METHOD] DEFAULT (''),
[TICKLER_DATE] [datetime] NULL,
[BATCH_NUM] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_BATCH_NUM] DEFAULT (''),
[CO_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_CO_ID] DEFAULT (''),
[UF_1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_UF_1] DEFAULT (''),
[UF_2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_UF_2] DEFAULT (''),
[UF_3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_UF_3] DEFAULT (''),
[UF_4] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_ActivityImporter_UF_4] DEFAULT ((0)),
[UF_5] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_ActivityImporter_UF_5] DEFAULT ((0)),
[UF_6] [datetime] NULL,
[UF_7] [datetime] NULL,
[ORIGINATING_TRANS_NUM] [int] NOT NULL CONSTRAINT [DF_ActivityImporter_ORIGINATING_TRANS_NUM] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_ORG_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_CAMPAIGN_CODE] DEFAULT (''),
[OTHER_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_OTHER_ID] DEFAULT (''),
[SOLICITOR_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_SOLICITOR_ID] DEFAULT (''),
[TAXABLE_VALUE] [money] NOT NULL CONSTRAINT [DF_ActivityImporter_TAXABLE_VALUE] DEFAULT ((0)),
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_UserID_Date] DEFAULT (''),
[RECURRING_REQUEST] [bit] NOT NULL CONSTRAINT [DF_ActivityImporter_RECURRING_REQUEST] DEFAULT ((0)),
[STATUS_CODE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ActivityImporter_STATUS_CODE] DEFAULT (''),
[NEXT_INSTALL_DATE] [datetime] NULL,
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iActivityImporterUserID_Date] ON [dbo].[ActivityImporter] ([UserID_Date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[ActivityImporter] TO [IMIS]
GRANT SELECT ON  [dbo].[ActivityImporter] TO [IMIS]
GRANT INSERT ON  [dbo].[ActivityImporter] TO [IMIS]
GRANT DELETE ON  [dbo].[ActivityImporter] TO [IMIS]
GRANT UPDATE ON  [dbo].[ActivityImporter] TO [IMIS]
GO